AirTran Airways Employee Data and Analysis
AirTran Airways
  1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010  
Traffic Indicies                                
Stage Length in Miles (for SLA purposes)                913               862             732             551             524             534             539             557              597              627              655               652              695              728              738              758
Seats Per Departure (for SDA purposes)               126               127             126             111             112             109             110             114              116              118              121               123              125              126              125              126
Price Per Gallon of Fuel  $             -    $             -    $           -    $        0.40  $        0.56  $        1.01  $        0.94  $        0.90  $          0.98  $          1.05  $          1.61  $          1.98  $          2.08  $          3.01  $          1.73  $          2.20
Airborne Hours / Block Hours 88% 87% 85% 90% 107% 94% 79% 78% 78% 79% 80% 81% 82% 82% 82% 82%
Outsourcing Indicies                                
Maintenance $'s Outsourced 0.0% 0.0% 0.0% 28.7% 16.6% 49.6% 54.6% 41.3% 47.2% 50.5% 54.2% 67.0% 67.9% 69.4% 72.4% 74.5%
Other Outsourcing as % of  Total Exp. (ex-Fuel) 0.0% 0.0% 2.2% 2.4% 3.4% 6.2% 5.9% 6.0% 5.1% 4.6% 5.2% 5.6% 6.1% 6.0% 6.5% 7.5%
Transport Related Expense (000)  $             -    $             -    $      1,016  $           -    $           -    $           -    $           -    $      1,064  $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -  
Productivity Measures (unadjusted)                                
Block Hours Per Employee Per Month
Pilots & Co-Pilots (note: Includes Flight Engineers where applicable)                 -                   -              33.1            52.0            62.6            59.2            51.4            53.4             56.0             57.5             56.8              58.3             59.2             58.7             58.1             55.8
Flight Attendants (note: Avg Crew = 1 FA per 50 seats)                 -                   -              70.1            44.1            53.2            46.4            47.3            49.6             51.6             50.5             53.6              54.3             56.0             58.8             55.9             56.4
Maintenance                 -                   -              41.1            37.1            43.9            46.2            42.8            53.4             65.6             72.2             88.4              95.0            108.3            113.0            124.5            120.6
Passenger, Cargo and Aircraft Handling                 -                   -              26.3            11.6             9.9            10.7            10.5            11.1             10.7             11.8             13.8              14.3             14.6             15.3             14.9             15.5
Other                 -                   -            263.2            18.9            18.7            19.6            19.5            22.5             25.2             23.5             28.5              33.0             33.4             35.5             35.1             36.9
Total                 -                   -               4.6             3.8             3.8             3.9             3.8             4.1               4.3               4.5               5.0               5.2               5.3               5.5               5.4               5.5
ASMs Per Employee (000)
Pilots & Co-Pilots                 -                   -         5,628.4     10,732.1     11,742.5     10,816.9     10,270.8     10,962.0       11,750.0       13,309.6       13,577.9       14,347.7       15,157.5       15,275.5       15,182.2       14,833.5
Flight Attendants                 -                   -       14,870.9       8,177.8       9,390.2       8,094.2       8,886.6       9,300.7         9,772.7         9,938.1       10,624.1       10,857.1       11,485.0       12,162.6       11,640.7       11,952.3
Maintenance                 -                   -       22,073.9     15,296.0     17,402.8     17,557.4     17,725.3     22,909.6       28,871.4       33,440.8       42,263.0       46,709.4       55,515.7       58,801.1       65,096.7       64,159.7
Passenger, Cargo and Aircraft Handling                 -                   -       14,127.3       4,771.1       3,906.3       4,058.2       4,329.5       4,755.6         4,700.0         5,461.9         6,579.9         7,017.6         7,488.8         7,972.7         7,799.4         8,225.6
Other                 -                   -      141,273.1       7,803.5       7,413.9       7,461.4       8,051.1       9,653.1       11,092.2       10,884.2       13,613.9       16,234.6       17,097.8       18,460.8       18,335.7       19,656.8
Total                 -                   -         2,482.8       1,548.1       1,497.3       1,466.4       1,557.4       1,779.4         1,888.8         2,064.9         2,382.1         2,563.8         2,734.3         2,883.5         2,835.1         2,923.8
Employees Per Aircraft
Pilots & Co-Pilots (Crews)                 -                   -               7.5             5.3             4.7             5.5             5.9             6.0               5.9               5.8               6.2               5.8               5.7               5.7               5.8               6.0
Flight Attendants (Crews)                 -                   -               3.5             6.3             5.5             7.0             6.4             6.5               6.5               6.6               6.6               6.2               6.0               5.7               6.0               6.0
Maintenance (Inhouse)                 -                   -               6.0             7.5             6.7             7.0             7.0             6.0               5.1               4.6               4.0               3.6               3.1               3.0               2.7               2.8
Passenger, Cargo and Aircraft Handling (Inhouse)                 -                   -               9.5            23.9            30.0            30.4            28.8            29.0             31.2             28.3             25.5              23.7             23.0             21.9             22.4             21.7
Other (Inhouse)                 -                   -               0.9            14.6            15.8            16.6            15.5            14.3             13.2             14.2             12.3              10.3             10.1               9.5               9.5               9.1
Total                 -                   -              53.8            73.7            78.1            84.3            80.1            77.5             77.6             74.8             70.5              65.0             62.9             60.6             61.6             61.1
Passengers Per Employee
Pilots & Co-Pilots                 -                   -            4,324        10,699        13,046        13,798        12,933        12,595          13,556          14,610          14,668          15,130          15,862          15,792          15,634          15,241
Flight Attendants                 -                   -          11,424          8,152        10,432        10,325        11,190        10,686          11,275          10,909          11,477          11,449          12,019          12,574          11,987          12,281
Maintenance                 -                   -          16,958        15,249        19,334        22,396        22,319        26,322          33,308          36,708          45,657          49,255          58,096          60,788          67,033          65,923
Passenger, Cargo and Aircraft Handling                 -                   -          10,853          4,756          4,340          5,177          5,452          5,464            5,422            5,996            7,108            7,400            7,837            8,242            8,031            8,452
Other                 -                   -        108,529          7,779          8,237          9,517        10,138        11,091          12,797          11,948          14,707          17,120          17,892          19,085          18,881          20,197
Total                 -                   -            1,907          1,543          1,663          1,870          1,961          2,044            2,179            2,267            2,573            2,704            2,861            2,981            2,919            3,004
Productivity Measures Revenue                                
Passenger Revenue Per Employee (000)
Pilots & Co-Pilots  $             -    $             -    $      404.4  $      802.5  $      982.8  $   1,105.7  $   1,010.1  $      930.3  $     1,032.1  $     1,112.0  $     1,227.7  $     1,365.9  $     1,463.7  $     1,536.6  $     1,354.1  $     1,446.0
Flight Attendants  $             -    $             -    $   1,068.5  $      611.5  $      785.9  $      827.4  $      874.0  $      789.3  $        858.4  $        830.3  $        960.6  $     1,033.6  $     1,109.1  $     1,223.5  $     1,038.2  $     1,165.1
Maintenance  $             -    $             -    $   1,586.0  $   1,143.8  $   1,456.5  $   1,794.7  $   1,743.2  $   1,944.3  $     2,535.9  $     2,793.9  $     3,821.4  $     4,446.7  $     5,360.9  $     5,914.9  $     5,806.0  $     6,254.2
Passenger, Cargo and Aircraft Handling  $             -    $             -    $   1,015.0  $      356.8  $      326.9  $      414.8  $      425.8  $      403.6  $        412.8  $        456.3  $        595.0  $        668.1  $        723.2  $        802.0  $        695.6  $        801.8
Other  $             -    $             -    $  10,150.3  $      583.5  $      620.5  $      762.7  $      791.8  $      819.2  $        974.3  $        909.4  $     1,231.0  $     1,545.5  $     1,651.1  $     1,857.0  $     1,635.4  $     1,916.1
Total  $             -    $             -    $      178.4  $      115.8  $      125.3  $      149.9  $      153.2  $      151.0  $        165.9  $        172.5  $        215.4  $        244.1  $        264.0  $        290.1  $        252.9  $        285.0
Salary and Benefits                                
Average Salary
Management and All Other  $             -    $             -    $   138,512  $    26,452  $    25,361  $    28,196  $    31,288  $    37,114  $      40,042  $      38,334  $      44,787  $      48,997  $      50,342  $      50,947  $      54,211  $      62,124
Pilots & Co-Pilots  $             -    $             -    $           -    $    54,838  $    65,770  $    68,926  $    75,335  $    85,709  $      89,593  $      98,055  $      95,809  $      96,527  $      99,311  $    100,952  $    104,265  $    108,549
Flight Attendants  $             -    $             -    $    56,152  $    20,122  $    17,580  $    14,840  $    17,882  $    18,509  $      20,399  $      22,710  $      24,879  $      26,244  $      27,388  $      29,706  $      30,463  $      31,816
Maintenance  $             -    $             -    $    35,473  $    34,448  $    39,265  $    45,906  $    46,020  $    46,589  $      50,154  $      52,389  $      55,813  $      56,465  $      60,663  $      64,257  $      74,303  $      72,739
Passenger, Cargo and Aircraft Handling  $             -    $             -    $      9,670  $    18,946  $    16,640  $    18,265  $    19,809  $    20,471  $      18,593  $      21,153  $      23,858  $      24,335  $      25,263  $      26,091  $      25,760  $      27,932
Total  $             -    $             -    $    29,427  $    27,722  $    27,126  $    29,189  $    32,783  $    35,951  $      36,253  $      38,725  $      42,319  $      43,517  $      45,062  $      47,014  $      48,307  $      52,191
Other Compensation Per Employee (All Employees)
Benefits, Pensions and Payroll Taxes
Pilots & Co-Pilots  $             -    $             -    $           -    $      2,649  $      2,262  $      2,776  $      6,344  $      4,338  $        6,300  $        9,440  $        9,240  $      10,702  $      10,803  $      10,501  $      11,677  $      11,573
All Others  $             -    $             -    $           -    $      1,357  $      1,345  $      2,179  $      1,697  $      3,643  $        4,094  $        4,566  $        4,664  $        4,834  $        5,192  $        6,368  $        6,770  $        7,512
Total  $             -    $             -    $      2,934  $      1,543  $      1,462  $      2,260  $      2,401  $      3,756  $        4,449  $        5,322  $        5,467  $        5,882  $        6,204  $        7,148  $        7,687  $        8,312
Personnel
Pilots & Co-Pilots  $             -    $             -    $           -    $      2,628  $      3,377  $      9,303  $      8,253  $      8,656  $        8,449  $        9,431  $        9,747  $      10,289  $      10,868  $      10,874  $      10,459  $      10,187
Flight Attendents  $             -    $             -    $    19,765  $      8,898  $    12,027  $    11,902  $    13,677  $    11,107  $      10,441  $      11,414  $      12,379  $      13,012  $      13,584  $      15,164  $      13,041  $      14,073
Payroll Taxes
Pilots & Co-Pilots  $             -    $             -    $           -    $      4,236  $      4,490  $      4,531  $      4,923  $      5,638  $        5,828  $        6,936  $        6,506  $        6,887  $        6,727  $        6,994  $        7,340  $        7,812
All Others  $             -    $             -    $           -    $      2,204  $      1,721  $      1,845  $      1,928  $      1,962  $        1,996  $        2,273  $        2,405  $        2,451  $        2,354  $        2,487  $        2,517  $        2,720
Raw Data                                
Number of Months 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12
Number of Days 365 366 365 365 365 366 365 365 365 366 365 365 365 365 365 365
P10- Employee Count Data                                
Sum of General Management                  49             126             162             169             136              48                45                44                45                52                60                60                66                70
Sum of Pilots and Co-Pilots                 106             429             467             525             619             732              818              902            1,133            1,325            1,498            1,559            1,535            1,622
Sum of Other Flight Personnel                 145               -                28              22              23              35                42                 -                   -                   -                   -                   -                   -                   -  
Sum of Passenger and General Services                  95             563             619             731             742             904            1,034            1,208            1,448            1,751            1,977            1,958            2,002            2,013
Sum of Maintenance                  64             301             334             337             372             367              350              359              364               407              409              405              358              375
Sum of AC Handling 1                 100               -                 -                 -                 -                 -                   -                   -                   -                   -                   -                   -                   -                   -  
Sum of Aircraft Handling                   -               930          1,441          1,404               -               651              869              905              953            1,103            1,232            1,226            1,225            1,197
Sum of Aircraft Control                   -                35              22              19             567              32                39                44                48                62                70                69                72                76
Sum of Passenger Handling                   -                 -                25              35             952          1,085            1,242            1,249            1,315            1,523            1,702            1,692            1,691            1,652
Sum of Cargo Handling                   -                 -                 -                 -                  4               -                   -                   -                  22                21                28                 -                   -                   -  
Sum of Trainees and Instructors                   -                28              37              21              31              38                34                34                32                35                39                28                26                27
Sum of Stats                  10              12              14              13              13              13                13                12                14                13                13                13                13                14
Sum of Traffic Solicitors                   -                 -                 -                 -                 -                 -                   -                   -                   -                   -                  23                30                33                35
Sum of Other                   -               550             733               -               775               -                864            1,057            1,084            1,123            1,253            1,219            1,199            1,148
Sum of Transport Related                   -                 -                 -               759               -               820                 -                   -                   -                   -                   -                   -                   -                   -  
Sum of Total             569          2,974          3,882          4,035          4,234          4,725            5,350            5,814            6,458            7,415            8,304            8,259            8,220            8,229
P6- Objective Grouping Operating Expense Data                                
Sum of Salaries-General Management Personnel (000)      $      3,287  $      4,433  $      7,263  $      8,493  $      9,155  $      9,603  $      10,332  $      13,350  $      16,600  $      19,626  $      20,959  $      22,993  $      24,986  $      27,186
Sum of Salaries-Flight Personnel (000)      $      5,334  $    34,855  $    43,438  $    48,551  $    61,634  $    82,471  $      98,142  $    115,879  $    144,577  $     173,851  $    202,914  $    215,547  $    221,033  $    240,112
Sum of Salaries-Maintenance Labor (000)      $      2,270  $    10,369  $    13,114  $    15,470  $    17,119  $    17,098  $      17,554  $      18,808  $      20,316  $      22,981  $      24,811  $      26,024  $      26,600  $      27,277
Sum of Salaries-Aircraft And Traffic Handling Personnel (000)      $         967  $    18,283  $    24,760  $    26,631  $    30,169  $    36,192  $      39,976  $      46,493  $      55,779  $      65,923  $      76,597  $      77,934  $      76,972  $      81,700
Sum of Salaries-Other Personnel (000)      $      4,885  $    14,507  $    16,728  $    18,631  $    20,726  $    24,504  $      27,948  $      30,620  $      36,025  $      40,297  $      48,915  $      45,785  $      47,494  $      53,203
Sum of Salaries-Total (000)  $    16,744  $    82,446  $   105,304  $   117,776  $   138,802  $   169,869  $    193,952  $    225,149  $    273,296  $     322,678  $    374,197  $    388,285  $    397,087  $    429,477
Sum of Related Fringe Benefits-Personnel Expense (000)  $      1,878  $      6,137  $      9,117  $    13,789  $    15,447  $    16,680  $      18,063  $      22,295  $      28,968  $      36,416  $      43,136  $      46,643  $      42,161  $      44,853
Sum of Related Fringe Benefits-Employee Benefits And Pensions (000)  $      1,670  $      4,589  $      5,676  $      9,118  $    10,167  $    17,748  $      23,801  $      30,943  $      35,305  $      43,617  $      51,522  $      59,036  $      63,184  $      68,403
Sum of Related Fringe Benefits-Payroll Taxes (000)  $      1,246  $      7,427  $      8,052  $      8,912  $    10,087  $    12,091  $      13,975  $      17,422  $      20,177  $      24,052  $      26,098  $      27,569  $      28,095  $      30,641
Sum of Related Fringe Benefits-Total (000)  $      4,794  $    18,153  $    22,844  $    31,820  $    35,701  $    46,518  $      55,839  $      70,660  $      84,450  $     104,086  $    120,756  $    133,248  $    133,440  $    143,897
Sum of Total Salaries And Related Fringe Benefits (000)  $    21,538  $   100,599  $   128,148  $   149,596  $   174,504  $   216,387  $    249,791  $    295,809  $    357,746  $     426,764  $    494,953  $    521,532  $    530,527  $    573,374
Sum of Services Purchased-Advertising And Other Promotions (000)  $      3,186  $      9,176  $    15,643  $    16,412  $    18,468  $    20,944  $      24,112  $      27,569  $      36,400  $      44,792  $      40,415  $      40,475  $      38,097  $      36,579
Sum of Services Purchased-Communication (000)  $      2,020  $      5,798  $      6,781  $      6,989  $      7,136  $      6,081  $        5,418  $        6,477  $        7,213  $        8,282  $        8,851  $      10,135  $      10,045  $      11,306
Sum of Services Purchased-Insurance (000)  $      4,319  $      6,254  $      2,507  $      5,332  $      8,090  $    25,651  $      19,592  $      19,203  $      19,186  $      20,668  $      18,363  $      16,674  $      16,332  $      17,632
Sum of Services Purchased-Outside Flight Equipment Maintenance (000)  $      1,360  $    12,104  $    18,147  $    47,122  $    49,845  $    28,219  $      39,676  $      47,290  $      65,984  $     105,107  $    121,906  $    133,493  $    166,638  $    197,835
Sum of Services Purchased-Traffic Commissions -Passenger (000)  $      5,486  $    26,268  $    19,435  $    12,833  $    13,625  $      9,527  $        6,412  $        8,240  $      10,649  $             -    $             -    $             -    $             -    $             -  
Sum of Services Purchased-Traffic Commissions-Cargo (000)  $           -    $           -    $           -    $           -    $           -    $           -    $             -    $             -    $             -    $             -    $             -    $             -    $             -    $             -  
Sum of Services Purchased-Other Services (000)  $      2,557  $      7,693  $    12,768  $    25,072  $    27,880  $    32,806  $      33,086  $      36,806  $      53,015  $      69,272  $      86,370  $      90,330  $    100,275  $    124,914
Sum of Services Purchased-Total (000)  $    18,928  $    63,094  $    75,281  $   113,761  $   125,043  $   123,229  $    128,295  $    145,584  $    192,446  $     248,121  $    275,905  $    291,106  $    331,387  $    388,265
Sum of Transport Related Expense (000) 1015.9 0 0 0 0 1063.81 0 0 0 0 0 0 0 0
Sum of Total Operating Expense (000)  $   118,018  $   381,327  $   447,721  $   542,944  $   609,844  $   702,167  $    831,721  $  1,008,579  $  1,437,156  $  1,851,222  $  2,172,057  $  2,624,488  $  2,164,432  $  2,490,982
T1 & T2- Traffic Data                                
Sum of RPMs 5.93E+07 9.34E+08 9.31E+08 2.65E+09 3.59E+09 4.15E+09 4.57E+09 5.67E+09 7.16E+09 8.49E+09 1.13E+10 1.38E+10 1.73E+10 1.88E+10 1.85E+10 1.96E+10
Sum of ASMs 1.15E+08 1.47E+09 1.41E+09 4.60E+09 5.81E+09 5.92E+09 6.59E+09 8.41E+09 1.01E+10 1.20E+10 1.54E+10 1.90E+10 2.27E+10 2.38E+10 2.33E+10 2.41E+10
Sum of Miles 9.12E+05 1.15E+07 1.12E+07 4.13E+07 5.18E+07 5.43E+07 5.99E+07 7.34E+07 8.70E+07 1.02E+08 1.28E+08 1.55E+08 1.82E+08 1.89E+08 1.86E+08 1.92E+08
Sum of Depts               998          13,396        15,256        74,979        98,852      101,676      111,128      131,950        145,784        162,527        194,970        237,114        261,707        260,200        251,785        252,664
Sum of Airborne Hours            2,141          26,580        26,848      120,811      188,686      175,212      150,848      183,170        213,969        246,464        307,670        373,918        434,362        450,399        438,997        447,268
Sum of Block Hours            2,424          30,555        31,583      133,905      175,885      186,735      191,230      235,177        275,640        311,008        386,073        463,821        531,649        549,355        535,037        542,586
Sum of AC Days               360            5,345          3,862        14,730        18,131        17,528        19,299        22,242          25,180          28,430          33,433          41,658          48,178          49,720          48,692          49,150
Sum of Gallons 1.42E+06 2.55E+07 2.48E+07 1.39E+08 1.22E+08 1.39E+08 1.49E+08 1.70E+08 1.82E+08 2.06E+08 2.55E+08 3.11E+08 3.60E+08 3.74E+08 3.63E+08 3.73E+08
Sum of Passengers        497,599      1,075,371    1,085,288    4,589,806    6,457,696    7,547,350    8,302,732    9,660,141    11,657,851    13,178,118    16,619,286    20,046,956    23,761,073    24,619,120    23,997,810    24,721,225
P12- Profit and Loss Statement                                
Sum of Pax Rev (000) 0.00E+00 0.00E+00 -1.02E+05 -3.44E+05 -4.86E+05 -6.05E+05 -6.48E+05 -7.14E+05 -8.88E+05 -1.00E+06 -1.39E+06 -1.81E+06 -2.19E+06 -2.40E+06 -2.08E+06 -2.35E+06
Sum of Charter Pax (000)  $             -    $             -    $        (246)  $           -    $           -    $           -    $           -    $     (2,053)  $       (2,382)  $       (2,241)  $       (6,297)  $       (6,371)  $       (6,285)  $     (18,082)  $     (10,417)  $       (9,619)
Sum of Transport Related Rev (000)  $             -    $             -    $     (1,264)  $           -    $           -    $           -    $           -    $     (1,901)  $             -    $             -    $             -    $             -    $             -    $             -    $       (2,748)  $       (3,866)
Sum of Cargo Rev (000)  $             -    $             -    $        (141)  $           -    $           -    $           -    $           -    $        (107)  $          (427)  $          (758)  $       (6,615)  $     (11,662)  $     (11,442)  $     (29,401)  $   (145,983)  $   (112,348)
Sum of Total Rev (000) 0.00E+00 0.00E+00 -1.06E+05 -3.69E+05 -5.23E+05 -6.24E+05 -6.65E+05 -7.33E+05 -9.18E+05 -1.04E+06 -1.45E+06 -1.89E+06 -2.31E+06 -2.55E+06 -2.34E+06 -2.62E+06
P52- Functional Grouping Operating Expense Data                                
Sum of Pilots And Copilots (000)  $    21,971  $    30,485  $    35,217  $    45,673  $    62,719  $      74,256  $      88,445  $    108,551  $     127,898  $    148,768  $    157,384  $    160,047  $    176,066
Sum of Other Flight Personnel (000)  $      1,555  $      2,071  $      2,486  $      2,693  $      3,019  $        2,794  $             -    $             -    $             -    $             -    $             -    $             -    $             -  
Sum of Trainees And Instructors (000)  $      1,835  $      2,006  $      2,746  $      4,780  $         813  $           793  $           927  $           884  $           945  $           945  $        1,165  $        1,514  $        1,561
Sum of Personnel Expenses (000)  $      1,127  $      1,672  $      5,089  $      5,299  $      6,639  $        7,266  $        8,506  $      11,043  $      13,633  $      16,280  $      16,952  $      16,054  $      16,524
Sum of Employee Benefits And Pensions (000)  $      1,136  $      1,120  $      1,518  $      4,073  $      3,327  $        5,418  $        8,515  $      10,469  $      14,180  $      16,183  $      16,371  $      17,925  $      18,771
Sum of Taxes-Payroll (000)  $      1,817  $      2,223  $      2,478  $      3,160  $      4,324  $        5,012  $        6,256  $        7,371  $        9,125  $      10,076  $      10,903  $      11,267  $      12,672
Sum of Total Flight Equipment Maintenance (Memo) (000)  $    42,245  $   109,536  $    95,080  $    91,339  $    68,328  $      84,138  $      93,658  $    121,677  $     156,911  $    179,645  $    192,459  $    230,259  $    265,519
Sum of Flying Operations-Aircraft Fuels (000)  $    55,270  $    68,331  $   140,404  $   139,355  $   154,104  $    178,737  $    215,256  $    410,459  $     615,039  $    748,765  $  1,128,143  $    629,662  $    818,983